Show All

Copy a macro module to another workbook

1. Set the security level to Medium.

   How?

   1. On the Tools menu, click Options.
   2. Click the Security tab.
   3. Under Macro Security, click Macro Security.
   4. Click the Security Level tab, and then select the security level you want to use.
2. Open the workbook that contains the module you want to copy and the workbook you want to copy the module to.
3. On the Tools menu, point to Macro, and then click Visual Basic Editor.
4. On the View menu, click Project Explorer .
5. Drag the module you want to copy to the destination workbook.